﻿using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace PropertyManagementSystemAPI.ModelTest {

	[JsonObject(MemberSerialization.OptIn), Table(Name = "systeminfo", DisableSyncStructure = true)]
	public partial class Systeminfo {

		/// <summary>
		/// 用户编号  主键
		/// </summary>
		[JsonProperty, Column(Name = "sysid", DbType = "int", IsPrimary = true)]
		public int Sysid { get; set; }

		/// <summary>
		/// 出生日期
		/// </summary>
		[JsonProperty, Column(Name = "birthday", DbType = "datetime")]
		public DateTime? Birthday { get; set; }

		/// <summary>
		/// 创建时间
		/// </summary>
		[JsonProperty, Column(Name = "createtime", DbType = "datetime")]
		public DateTime? Createtime { get; set; }

		/// <summary>
		/// 是否删除
		/// </summary>
		[JsonProperty, Column(Name = "isdelete")]
		public bool Isdelete { get; set; }

		/// <summary>
		/// 角色id  外键
		/// </summary>
		[JsonProperty, Column(Name = "roleid", DbType = "int")]
		public int? Roleid { get; set; }

		/// <summary>
		/// 身份证号码
		/// </summary>
		[JsonProperty, Column(Name = "sysidcard", DbType = "char(18)")]
		public string Sysidcard { get; set; }

		/// <summary>
		/// 用户照片
		/// </summary>
		[JsonProperty, Column(Name = "sysimg")]
		public string Sysimg { get; set; }

		/// <summary>
		/// 用户名
		/// </summary>
		[JsonProperty, Column(Name = "sysname", StringLength = 50)]
		public string Sysname { get; set; }

		/// <summary>
		/// 用户登录密码
		/// </summary>
		[JsonProperty, Column(Name = "syspassword", StringLength = 50)]
		public string Syspassword { get; set; }

		/// <summary>
		/// 用户姓名
		/// </summary>
		[JsonProperty, Column(Name = "sysrealname", StringLength = 50)]
		public string Sysrealname { get; set; }

		/// <summary>
		/// 性别
		/// </summary>
		[JsonProperty, Column(Name = "syssex", DbType = "char(2)")]
		public string Syssex { get; set; }

		/// <summary>
		/// 用户状态 （0 可用 1禁用）
		/// </summary>
		[JsonProperty, Column(Name = "sysstate")]
		public bool? Sysstate { get; set; }

		/// <summary>
		/// 联系电话
		/// </summary>
		[JsonProperty, Column(Name = "telephone", DbType = "char(11)")]
		public string Telephone { get; set; }

	}

}
